from openpyxl import load_workbook
# 下面的前提是 完成1.新建与保存.py后
wb = load_workbook(r'D:\Desktop\exceltest\my.xlsx')

wb.create_sheet(title='my1', index=1)
wb.create_sheet(title='my2', index=2)
wb.create_sheet(title='my3', index=3)
wb.create_sheet(title='my4', index=4)
wb.create_sheet(title='my5', index=5)

print(f'此时这个excel文件的sheet名字有{wb.sheetnames}')

# 创建后保存的路径
wb.save(r'D:\Desktop\exceltest\my.xlsx')
